/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.132_supermarket
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : 192.168.1.132
 Source Database       : supermarket

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : utf-8

 Date: 06/17/2020 11:37:49 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ag_interface_auth`
-- ----------------------------
DROP TABLE IF EXISTS `ag_interface_auth`;
CREATE TABLE `ag_interface_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `res_id` int(11) DEFAULT NULL COMMENT '资源id',
  `api` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口地址',
  `app_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '自建系统代码',
  `state` tinyint(3) DEFAULT NULL COMMENT '状态 0-无效 1-有效',
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '访问来源ip',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `ag_interface_auth`
-- ----------------------------
BEGIN;
INSERT INTO `ag_interface_auth` VALUES ('32', '2314', '1', '1', 'test1', '1', '123', '2019-08-28 16:33:25'), ('33', null, '2', null, 'test1', '0', '123', '2019-08-28 16:42:41');
COMMIT;

-- ----------------------------
--  Table structure for `gs_app`
-- ----------------------------
DROP TABLE IF EXISTS `gs_app`;
CREATE TABLE `gs_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '唯一代码',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '系统简介',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `user_id` int(11) NOT NULL COMMENT '所属用户id',
  `def` tinyint(3) DEFAULT '0' COMMENT '是否默认。0 否， 1 是',
  `state` tinyint(3) DEFAULT '0' COMMENT '状态 0 正常，1 作废',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='自建系统';

-- ----------------------------
--  Records of `gs_app`
-- ----------------------------
BEGIN;
INSERT INTO `gs_app` VALUES ('1', '测试系统1', 'test1', '', '37', '1', '0', '0', '2019-07-17 12:38:48', '2019-12-11 10:29:28'), ('2', '测试系统2', 'test2', '测试', '37', '1', '0', '0', '2019-07-17 12:39:18', '2019-12-11 10:29:28'), ('3', '测试系统3', 'test3', '测试', '37', '1', '0', '1', '2019-07-17 12:39:51', '2019-12-11 10:29:28'), ('4', '2', '2', '2', '37', '2', '1', '0', '2019-07-17 12:47:47', '2019-12-11 10:29:29'), ('5', '测试系统5', 'test5', '测试', '37', '2', '1', '1', '2019-07-17 12:48:10', '2019-12-11 10:29:29'), ('8', '测试系统8', 'test8', '测试', null, '2', '0', '0', '2019-07-17 13:02:15', '2019-07-17 16:45:59'), ('9', '凹凸曼', '420a9c03-190c-4b71-bfd1-bf2b8997b123', '123', null, '1', '0', '0', '2019-08-23 14:41:38', '2019-10-18 14:32:59'), ('10', '', '5245c911-39c3-4618-b18c-b94e257d42fe', '', null, '1', '0', '0', '2019-08-23 14:45:29', null), ('11', '123', '01179add-f8d8-4c1c-b57e-c5b73ac4675c', '123', null, '1', '0', '0', '2019-08-23 14:48:00', null), ('12', '', '8abd61e1-8114-4f1f-a94b-1872f8e203b6', '', null, '1', '0', '0', '2019-08-23 14:49:02', null), ('13', '123', '479ee63b-9a9f-40c7-91a6-c00ef055eb17', '123', null, '1', '0', '0', '2019-08-23 14:49:55', null), ('14', '123', 'b00d1ca0-bb86-441f-838e-00ffd860152c', '123', null, '1', '0', '0', '2019-08-23 14:50:28', null), ('15', '123', '5302c1e9-ff53-4131-ac02-1391fa4a0dc6', '123', null, '1', '0', '0', '2019-08-23 14:51:25', null), ('16', '', 'af775213-6673-4ada-a326-9e084652ef93', '', null, '1', '0', '0', '2019-08-23 14:51:53', null), ('17', '12ed', 'a29c5380-a3cb-4033-8110-32453711d3cb', '', null, '1', '0', '0', '2019-08-23 14:52:07', '2019-08-26 14:17:49'), ('18', 'xxxxxxx', 'e5a72724-5a36-47e4-ac43-9a5739920b7c', '', null, '1', '0', '0', '2019-08-23 14:52:49', '2019-08-26 11:42:56'), ('19', 'xxx', '48c787b2-5ce4-43b9-92aa-4c96db77c5e3', '', null, '1', '0', '0', '2019-08-23 14:56:46', '2019-08-26 11:36:41'), ('20', '12345678', 'fb8c1fb7-3689-4a9e-b0a6-81b349336819', '', null, '1', '0', '0', '2019-08-23 14:56:52', '2019-08-26 11:11:27'), ('21', '撸啦啦噜啦噜啦噜啦嘞', '5a8cbaf1-ddac-41a6-b94e-5effe01fd73c', '', null, '1', '0', '0', '2019-08-23 14:57:06', '2019-08-26 11:13:09'), ('22', '略略略', '79fdc6bb-9b24-487b-acdf-55369ea57da9', '', null, '1', '0', '0', '2019-08-23 14:57:35', '2019-08-26 11:09:58'), ('23', '上山打老虎', 'f22f1277-b4d1-4610-b96a-6b1ccf9203a1', '', null, '1', '0', '0', '2019-08-23 14:59:25', '2019-08-26 10:58:41'), ('24', '12345', 'c93a5c86-6b92-471d-81bf-09faa20a5c85', '', null, '1', '0', '0', '2019-08-23 14:59:41', '2019-08-26 10:57:59'), ('25', '哈哈哈哈', '70194479-2c0f-4814-8b8a-7b7e0a0d8e96', '', null, '1', '0', '0', '2019-08-23 15:01:04', '2019-08-26 10:56:38'), ('26', '123', 'c9f564e8-838b-44c7-a720-7eeab214bc99', '', null, '1', '0', '0', '2019-08-23 15:01:44', '2019-08-26 10:51:50'), ('27', '宝塔镇河妖', '8ccacae7-46ee-4245-a6ce-b285f13872f8', '', null, '1', '0', '0', '2019-08-23 15:55:59', '2019-08-26 10:54:41'), ('28', '天王盖地虎', '129c2ec6-c0c4-4925-85da-a1d6262fa02f', '', null, '1', '0', '0', '2019-08-23 16:05:05', '2019-08-26 10:52:38'), ('29', '', 'e7c45152-1655-410a-b415-e649f34f9dd9', '', null, '1', '0', '0', '2019-08-27 18:57:19', null), ('30', '123', 'fc949fd3-f744-44d2-a267-34e314b86756', '123', null, '166', '0', '0', '2019-08-30 16:55:44', '2019-10-17 17:10:56'), ('31', '1111', '7049c11a-2e15-401f-945e-c6bef1ae184e', '', null, '1', '0', '0', '2019-09-02 09:18:33', null), ('32', '自建系统1号', '90efdcc9-e2a1-4518-aae8-102002706051', '自建系统1号', null, '168', '0', '0', '2019-09-02 15:39:04', null), ('33', '自建系统2号', 'a636ff5a-9a15-4368-8cc9-a5c2db9287fe', '自建系统2号', null, '168', '0', '0', '2019-09-02 15:39:37', null), ('34', '6666', '78edc2d0-3386-486a-8230-52d51728cea6', '123123asdasf', null, '166', '0', '0', '2019-09-03 16:38:31', '2019-10-17 17:08:09'), ('35', '测试自建系统', '7a9ba748-6ad5-4ea0-a4f9-1a7d16b0b520', '2222222222222222222222222222', null, '166', '0', '0', '2019-09-03 16:41:44', '2019-10-14 14:23:13'), ('36', '测试系统1', '89f27343-7e3f-432e-aade-7c07e3137c6d', '', null, '166', '0', '0', '2019-09-03 16:45:18', '2019-09-19 14:47:02'), ('37', '测试自建系统1', 'b16c5b93-ec00-4dbb-a473-a8350faa31fa', '这是测试这是测试这是测试这是测试这是测试', null, '169', '0', '0', '2019-09-10 18:24:51', null), ('38', '自建系统1', 'fc51f1da-11db-4853-a39b-4e5fa246dc2e', '', null, '54', '0', '0', '2019-09-16 17:00:34', '2019-09-19 11:29:37'), ('39', '123123', '56dba51e-f4db-487e-a3c9-26583954fe98', '', null, '174', '0', '0', '2019-09-19 16:47:26', '2019-09-23 14:30:03'), ('40', '自建系统1', '5c37e93f-3060-4e9f-b47c-b6da0ddd5b53', '', null, '180', '0', '0', '2019-09-29 09:12:22', '2019-09-29 10:34:00'), ('41', '自建系统2', 'f1ef6a26-f22c-4bd2-b2d8-7e8b00b02bad', '123', null, '180', '0', '0', '2019-09-29 16:12:46', null), ('42', '测试122', 'ff983e6c-9f92-4171-bfdc-6ceffc25b795', '222222222222', null, '166', '0', '0', '2019-10-14 11:48:21', '2019-10-14 11:55:23'), ('43', '测试修改', 'cd62141b-aace-4278-ac16-4928eba27653', '修改', null, '166', '0', '0', '2019-10-14 11:56:35', '2019-10-14 16:54:03'), ('44', '测试00', 'd713004f-46b5-41fd-a4b1-2113b4fc7f65', '测试00', null, '166', '0', '0', '2019-10-14 17:00:11', null), ('45', '测试测试测试', '0faf768a-25b8-491e-8885-a04cbf945acb', '1111111', null, '166', '0', '0', '2019-10-14 17:47:05', null), ('46', '111', '640de453-c386-4054-b1dc-100617d66fb7', '2222', null, '166', '0', '0', '2019-10-14 17:48:49', null), ('47', '哈哈', '655cbce9-a95e-48b1-9072-4c630b9ad77c', '哈哈哈', null, '166', '0', '0', '2019-10-21 10:00:45', null), ('48', '测试v', '939ce985-ac4b-4469-9a6e-8c0fd9e1c117', '测试', null, '166', '0', '0', '2019-11-08 10:32:23', '2019-11-08 10:42:53'), ('49', 'ddd', '7678ffe6-e572-4895-9d2f-bf9ec300c275', '111', null, '166', '0', '0', '2019-11-08 10:44:37', null), ('50', '部门自建系统', 'ca6b1b47-1ef1-4ee0-8f41-e6f6fe56f62d', '1111', null, '166', '0', '0', '2019-12-11 10:25:31', null), ('51', '测试自建系统', '23f19696-ae0c-48c4-a581-b3849533e5fa', '测试自建系统', '1', '224', '0', '0', '2020-03-20 16:27:44', null), ('52', '杭州市社保局自建系统', 'f47c15d1-7116-45b7-ac49-fd31273e3217', '杭州市社保局自建系统', '18', '231', '0', '0', '2020-06-11 11:27:02', null);
COMMIT;

-- ----------------------------
--  Table structure for `gs_app_interface`
-- ----------------------------
DROP TABLE IF EXISTS `gs_app_interface`;
CREATE TABLE `gs_app_interface` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '自建系统code',
  `res_id` int(11) DEFAULT NULL COMMENT '资源ID',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `api` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '接口地址',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_app_interface`
-- ----------------------------
BEGIN;
INSERT INTO `gs_app_interface` VALUES ('1', 'test1', '2', '11111', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `gs_app_ip`
-- ----------------------------
DROP TABLE IF EXISTS `gs_app_ip`;
CREATE TABLE `gs_app_ip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) DEFAULT NULL COMMENT 'appID',
  `ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'IP地址',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `res_id_list` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源ID列表',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_app_ip`
-- ----------------------------
BEGIN;
INSERT INTO `gs_app_ip` VALUES ('1', '1', '12312123', '2019-08-22 15:07:09', null), ('2', '31', '1.1.2.3', '2019-09-02 09:18:33', null), ('3', '32', '1.2.2.2', '2019-09-02 15:39:04', null), ('4', '33', '1.1.1.1', '2019-09-02 15:39:37', null), ('5', '33', '2.2.2.2', '2019-09-02 15:39:37', null), ('6', '33', '3.3.3.3', '2019-09-02 15:39:37', null), ('7', '34', '1.1.1.1', '2019-09-03 16:38:31', null), ('8', '35', '2.2.2.3', '2019-09-03 16:41:44', null), ('9', '35', '3.3.3.3', '2019-09-03 16:41:44', null), ('10', '35', '5.5.5.5', '2019-09-03 16:41:44', null), ('11', '35', '1.1.1.1', '2019-09-03 16:41:44', null), ('12', '37', '192.168.1.112', '2019-09-10 18:24:51', null), ('13', '38', '1.1.1.1', '2019-09-16 17:00:34', null), ('14', '39', '192.169.1.1', '2019-09-26 18:38:05', '41'), ('33', '35', '192.168.1.100', null, null), ('34', '40', '1.1.1.1', '2019-09-29 09:12:22', null), ('35', '40', '1.1.1.2', '2019-09-29 09:12:22', null), ('36', '41', '192.168.2.1', '2019-09-29 16:12:46', null), ('37', '41', '192.168.2.2', '2019-09-29 16:12:46', null), ('38', '42', '12.12.12.13', '2019-10-14 11:48:22', null), ('39', '42', '12.12.12.14', '2019-10-14 11:48:22', null), ('40', '42', '12.12.12.15', '2019-10-14 11:48:22', null), ('41', '42', '12.12.12.16', null, null), ('42', '42', '12.12.12.16', null, null), ('43', '42', '12.12.12.17', null, null), ('44', '43', '12.12.12.0', '2019-11-28 11:40:30', ''), ('45', '43', '12.12.12.0', '2019-11-28 11:40:30', ''), ('54', '44', '12.12.12.6', '2019-10-14 17:00:11', null), ('55', '45', '127.0.0.1', '2019-10-14 17:47:05', null), ('56', '45', '127.0.0.1', '2019-10-14 17:47:05', null), ('57', null, null, null, 'null,38'), ('58', null, null, null, 'null,38'), ('83', '34', '127.1.0.1', null, null), ('87', '30', '127.0.0.1', null, null), ('88', '9', '12.12.12.0', null, null), ('89', '9', '12.12.12.1', null, null), ('90', '47', '139.0.0.3', '2019-11-28 11:40:00', '38'), ('91', null, null, null, 'null,39'), ('92', null, null, null, 'null,51'), ('93', '49', '127.0.0.1', '2019-11-08 10:44:37', null), ('94', '49', '127.0.0.2', '2019-11-08 10:44:37', null), ('95', '51', '136.153.24.1', '2020-03-20 16:27:44', null), ('96', '52', '135.166.12.155', '2020-06-11 11:27:03', null);
COMMIT;

-- ----------------------------
--  Table structure for `gs_app_ip_apply`
-- ----------------------------
DROP TABLE IF EXISTS `gs_app_ip_apply`;
CREATE TABLE `gs_app_ip_apply` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_id` int(11) NOT NULL COMMENT '自建系统ID',
  `ip_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ip变动ID列表',
  `apply_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请单号',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `user_id` int(11) DEFAULT NULL COMMENT '申请人id',
  `content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请内容',
  `state` tinyint(3) DEFAULT NULL COMMENT '（0未确认 1未提交、2待审批、3已提交至审批中心、4审批中、5已撤回、6审批通过、7已驳回）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_done` tinyint(3) DEFAULT NULL COMMENT '是否完成，用于订单申请通过后给用户发放资源 0-未发放 1-已发放',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_app_ip_apply`
-- ----------------------------
BEGIN;
INSERT INTO `gs_app_ip_apply` VALUES ('2', '39', '2,', '77c9e4384006479cac9b6b98d8c9a0ad', null, '174', '生成修改类型IP需求申请单', '6', '2019-09-26 11:43:55', '1'), ('3', '40', '3,', 'a20c0ee2a3984dcc823793533e922043', null, '180', '生成修改类型IP需求申请单', '3', '2019-09-29 10:33:58', '0'), ('4', '42', '4,', '400559d86fbc45d7888169fd66bb5c1b', null, '166', '生成修改类型IP需求申请单', '3', '2019-10-14 11:55:23', '0'), ('5', '34', '5,6,', 'bf9c390af2bf4531bfd515601acd84ab', null, '166', '生成修改类型IP需求申请单', '3', '2019-10-14 14:25:27', '0'), ('6', '43', '7,8,9,10,', '5f65e81b7f794abea86d347bde86219a', null, '166', '生成修改类型IP需求申请单', '6', '2019-10-14 16:54:03', '1'), ('7', '47', '11,', '7e573dfc6dd74cd29d25198d663652f3', null, '166', '生成修改类型IP需求申请单', '6', '2019-10-21 10:22:19', '1'), ('8', '48', '12,13,', '8021e95fae2840b485a7e07e408c414f', null, '166', '生成修改类型IP需求申请单', '3', '2019-11-08 10:42:52', '0'), ('9', '49', '14,15,', 'a2e2ca2d8d7741a19976036405c31785', null, '166', '生成修改类型IP需求申请单', '3', '2019-11-08 10:48:54', '0');
COMMIT;

-- ----------------------------
--  Table structure for `gs_approve_flow`
-- ----------------------------
DROP TABLE IF EXISTS `gs_approve_flow`;
CREATE TABLE `gs_approve_flow` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `apply_id` int(11) DEFAULT NULL COMMENT '用户流程id',
  `user_id` int(11) DEFAULT NULL COMMENT '审核用户',
  `result` tinyint(3) DEFAULT NULL COMMENT '审核结果 1-通过 2-驳回',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '审核意见',
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='审批记录';

-- ----------------------------
--  Table structure for `gs_approve_flow_config`
-- ----------------------------
DROP TABLE IF EXISTS `gs_approve_flow_config`;
CREATE TABLE `gs_approve_flow_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `flow_type` tinyint(3) DEFAULT NULL COMMENT '流程分类',
  `config_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '流程配置编码',
  `section` int(11) DEFAULT NULL COMMENT '环节',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门',
  `role_id` int(11) DEFAULT NULL COMMENT '角色',
  `next_flow` int(11) DEFAULT NULL COMMENT '下个流程id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='流程配置';

-- ----------------------------
--  Records of `gs_approve_flow_config`
-- ----------------------------
BEGIN;
INSERT INTO `gs_approve_flow_config` VALUES ('1', '1', 'query_platform', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `gs_approve_flow_type`
-- ----------------------------
DROP TABLE IF EXISTS `gs_approve_flow_type`;
CREATE TABLE `gs_approve_flow_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` tinyint(3) DEFAULT NULL COMMENT '流程分类',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '流程分类名',
  `apply_form` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请单',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='流程分类-申请单关联';

-- ----------------------------
--  Table structure for `gs_banner_manage`
-- ----------------------------
DROP TABLE IF EXISTS `gs_banner_manage`;
CREATE TABLE `gs_banner_manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `banner_img_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'banner图片url',
  `banner_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'banner路径',
  `open_type` int(1) DEFAULT NULL COMMENT '打开方式：0当前页面打开 1新页面打开',
  `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_banner_manage`
-- ----------------------------
BEGIN;
INSERT INTO `gs_banner_manage` VALUES ('1', '7021e839-8825-4d8f-8fa4-9dd114ba8e56', '/pathssss', '0', '2019-10-16 16:00:41', '2019-10-16 16:00:41');
COMMIT;

-- ----------------------------
--  Table structure for `gs_category_manage`
-- ----------------------------
DROP TABLE IF EXISTS `gs_category_manage`;
CREATE TABLE `gs_category_manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类名称',
  `pid` int(11) DEFAULT NULL COMMENT '父ID',
  `level` int(11) DEFAULT NULL COMMENT '级别',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_category_manage`
-- ----------------------------
BEGIN;
INSERT INTO `gs_category_manage` VALUES ('2', '数据处理1', '1', '1', '2019-08-06 15:35:23'), ('8', '政务处理', '1', '2', '2019-08-06 15:35:42'), ('22', '新增测试分类数据', '1', '3', '2019-08-19 12:02:46'), ('27', '222', '1', '4', '2019-09-25 11:23:19'), ('31', '测试分类', '1', '5', '2019-09-29 09:21:15'), ('33', '测测测测', '1', '6', '2019-09-29 09:22:11'), ('41', '12', '40', '1', '2019-09-29 10:19:27'), ('44', '11-1', '42', '1', '2019-09-29 10:25:44'), ('47', '111-1', '45', '1', '2019-09-29 10:55:39'), ('49', '222-1', '48', '1', '2019-09-29 10:55:58'), ('51', '2', '50', '1', '2019-10-12 11:39:56'), ('53', '1', '1', '7', '2019-10-14 17:07:51'), ('54', '老大', '0', '1', '2019-10-15 17:22:48'), ('55', '2', '0', '2', '2019-10-15 17:23:16'), ('56', '老大二', '54', '1', '2019-10-15 17:23:23'), ('58', '33', '55', '1', '2019-10-16 10:33:16');
COMMIT;

-- ----------------------------
--  Table structure for `gs_cooperation_unit`
-- ----------------------------
DROP TABLE IF EXISTS `gs_cooperation_unit`;
CREATE TABLE `gs_cooperation_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `logo_img_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'logo图片url',
  `cooperation_unit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '合作单位名称',
  `page_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '页面链接',
  `open_type` int(1) DEFAULT NULL COMMENT '打开方式 0当前页面 1新页面',
  `display_status` int(1) DEFAULT NULL COMMENT '显示状态 0显示 1隐藏',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_cooperation_unit`
-- ----------------------------
BEGIN;
INSERT INTO `gs_cooperation_unit` VALUES ('16', 'cffe396b-c41e-4dbd-bc46-999447b05d0b', '123123', 'http://www.baidu.com', '1', '0', '1', '2019-10-17 14:08:47'), ('17', 'a40d8796-49a9-4f00-b654-633003ad228f', '宇宙', 'yuyuyuz', '1', '0', '2', '2019-10-17 16:46:29');
COMMIT;

-- ----------------------------
--  Table structure for `gs_file`
-- ----------------------------
DROP TABLE IF EXISTS `gs_file`;
CREATE TABLE `gs_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件名称',
  `size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件大小',
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件分类、标识',
  `res_id` int(11) DEFAULT NULL COMMENT '所属资源id',
  `upload_time` datetime DEFAULT NULL COMMENT '上传时间',
  `upload_user_id` int(11) DEFAULT NULL COMMENT '上传用户',
  `state` tinyint(4) DEFAULT NULL COMMENT '状态。0正常 1作废',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Table structure for `gs_home_manage`
-- ----------------------------
DROP TABLE IF EXISTS `gs_home_manage`;
CREATE TABLE `gs_home_manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `moduleName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '模块名称',
  `modulePath` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '模块编辑路径',
  `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_home_manage`
-- ----------------------------
BEGIN;
INSERT INTO `gs_home_manage` VALUES ('1', 'Banner', '/banner\r\n', '2019-10-16 16:00:41', '2019-07-30 15:36:30'), ('2', '热门产品', '/hotProducts', '2019-10-16 15:56:48', '2019-07-30 15:36:51'), ('3', '产品特色', '/featuredProducts', '2019-10-17 16:44:24', '2019-07-30 15:37:12'), ('4', '合作单位', '/unitCooperation', '2020-04-02 14:27:05', '2019-07-30 15:37:25');
COMMIT;

-- ----------------------------
--  Table structure for `gs_hot_res`
-- ----------------------------
DROP TABLE IF EXISTS `gs_hot_res`;
CREATE TABLE `gs_hot_res` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
  `open_type` int(2) NOT NULL COMMENT '打开方式 0 当前页面 1-新页面',
  `display_status` int(11) DEFAULT NULL COMMENT '显示状态 0-显示 1-隐藏',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '首页说明',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `res_id` int(11) DEFAULT NULL COMMENT '关联应用的ID',
  `img_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '显示图片的URL',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_hot_res`
-- ----------------------------
BEGIN;
INSERT INTO `gs_hot_res` VALUES ('44', '测试性应用', '1', '0', '说明1111', '2', '15', '007a8fb1-51e7-4755-9bd0-9a896235a099', '2019-08-19 14:35:51'), ('51', '太阳', '0', '0', '22222', '1', '40', '684ebc46-418d-44e6-b80b-a261b5da56f4', '2019-08-19 17:51:27'), ('52', '月亮', '1', '0', '这是测试', '3', '45', 'fb639f4c-e4eb-40ee-b286-0c471e53750e', '2019-10-16 11:14:02');
COMMIT;

-- ----------------------------
--  Table structure for `gs_ip_change`
-- ----------------------------
DROP TABLE IF EXISTS `gs_ip_change`;
CREATE TABLE `gs_ip_change` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` int(5) DEFAULT NULL COMMENT '变动类型: 0-新增 1-修改',
  `app_id` int(11) DEFAULT NULL COMMENT '自建系统ID',
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ip地址',
  `aims_id` int(11) DEFAULT NULL COMMENT '如果是修改，则指定要修改的数据的ID,否则为null即可',
  `res_id_list` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源列表',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_ip_change`
-- ----------------------------
BEGIN;
INSERT INTO `gs_ip_change` VALUES ('2', '0', '39', '192.169.1.1', '14', '41', '2019-09-26 11:43:55'), ('3', '0', '40', '1.1.1.1', '34', '38', '2019-09-29 10:33:58'), ('4', '0', '42', '12.12.12.13', '38', '', '2019-10-14 11:55:23'), ('5', '0', '34', '1.1.1.6', '7', '', '2019-10-14 14:25:27'), ('6', '0', '34', '1.1.1.6', '7', '', '2019-10-14 14:25:27'), ('7', '0', '43', '12.12.12.0', '44', '', '2019-10-14 16:54:03'), ('8', '0', '43', '12.12.12.0', '44', '', '2019-10-14 16:54:03'), ('9', '0', '43', '12.12.12.0', '45', '', '2019-10-14 16:54:03'), ('10', '0', '43', '12.12.12.0', '45', '', '2019-10-14 16:54:03'), ('11', '0', '47', '139.0.0.3', '90', '38', '2019-10-21 10:22:19'), ('12', '0', '48', '127.0.0.2', '92', '38', '2019-11-08 10:42:52'), ('13', '0', '48', '127.0.0.2', '92', '38', '2019-11-08 10:42:52'), ('14', '0', '49', '127.0.0.3', '93', '39', '2019-11-08 10:48:54'), ('15', '0', '49', '127.0.0.3', '93', '39', '2019-11-08 10:48:54');
COMMIT;

-- ----------------------------
--  Table structure for `gs_navigation`
-- ----------------------------
DROP TABLE IF EXISTS `gs_navigation`;
CREATE TABLE `gs_navigation` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` tinyint(3) DEFAULT NULL COMMENT '1-路径 2-分类',
  `navigation_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '导航名称',
  `navigation_path` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '导航路径',
  `open_type` int(2) DEFAULT NULL COMMENT '打开方式 0 当前页面打开 1 新页面打开',
  `float_show` int(2) DEFAULT NULL COMMENT '浮窗显示 0-是 1否',
  `display_status` int(2) DEFAULT NULL COMMENT '显示状态 0 显示  1隐藏',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `remark` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_navigation`
-- ----------------------------
BEGIN;
INSERT INTO `gs_navigation` VALUES ('2', '1', '菜单管理', '/list', '0', '0', '0', '2', '无', '2019-07-24 15:00:54'), ('3', '2', '分类浮窗', '54', '0', '1', '0', '3', '无', '2019-07-24 15:03:35'), ('43', '2', '政务处理', '1', '0', '0', '0', '4', null, null), ('47', '1', '首页', '/home', '0', '0', '0', '1', null, '2019-08-30 10:06:02'), ('48', '1', '百度', 'http://www.baidu.com', '0', '0', '0', '5', null, '2019-08-30 10:45:37');
COMMIT;

-- ----------------------------
--  Table structure for `gs_notice`
-- ----------------------------
DROP TABLE IF EXISTS `gs_notice`;
CREATE TABLE `gs_notice` (
  `notice_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `notice_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '通知名称',
  `notice_content_text` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '通知详情-md文本',
  `notice_content_html` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '通知详情-Html',
  `notice_start_time` datetime DEFAULT NULL COMMENT '通知开始时间',
  `notice_end_time` datetime DEFAULT NULL COMMENT '通知结束时间',
  `notice_platform_id` int(11) DEFAULT NULL COMMENT '发布平台ID',
  `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
  `notice_status` int(2) DEFAULT NULL COMMENT '通知状态:0 未开始 1 公告中 2 已结束',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注信息',
  `user_id` int(11) DEFAULT NULL COMMENT '通知用户',
  `b_read` tinyint(3) DEFAULT NULL COMMENT '是否已读 0-否 1-是',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_notice`
-- ----------------------------
BEGIN;
INSERT INTO `gs_notice` VALUES ('2', '应用超市19日0:00——8:00维护', null, '详情', '2019-07-23 16:05:17', '2019-07-24 16:05:21', '9', '2019-07-23 16:05:28', '2', '暂无', '1', null, '2019-07-23 16:05:44'), ('3', '应用超市13日0:00——8:00维护', null, '通知详情', '2019-08-13 14:52:04', '2019-08-14 14:52:06', '10', '2019-08-13 14:52:16', '2', '无', '1', null, '2019-08-13 14:52:26'), ('6', '云服务器将于15日进行维护更新', '3', '3', '2019-08-13 17:29:48', '2019-08-14 17:29:49', '40', '2019-08-13 17:29:55', '2', '0', null, null, '2019-08-13 17:30:02'), ('7', '云服务器将于16日进行维护更新', '4', '4', '2019-08-13 17:30:12', '2019-08-15 17:30:13', '51', '2019-08-13 17:30:20', '2', '0', null, null, '2019-08-13 17:30:26'), ('8', '云服务器将于17日进行维护更新', '5', '5', '2019-08-22 17:30:36', '2019-08-29 17:30:38', '59', '2019-08-13 17:30:44', '2', '0', null, null, '2019-08-13 17:30:49'), ('9', '云服务器将于18日进行维护更新', '6', '6', '2019-08-21 17:31:57', '2019-08-23 17:32:00', '60', '2019-08-13 17:32:05', '2', '0', null, null, '2019-08-13 17:32:10'), ('13', '测试', '889', '889', '2019-08-28 17:38:42', '2019-08-30 17:38:44', '40', '2019-08-13 17:38:49', '2', '0', null, null, '2019-08-13 17:38:56'), ('43', '66666666666666', '11', '11', '2019-08-26 09:51:21', '2019-09-26 16:05:19', '1', '2019-08-26 10:21:26', '2', '暂无', null, null, '2019-08-26 10:20:25'), ('45', '77777777777', '11', '11', '2019-08-26 09:51:21', '2019-09-26 16:05:19', '1', '2019-08-26 14:49:09', '2', '暂无', null, null, '2019-08-26 14:49:09'), ('51', '20190826测试通知1', '111', null, '2019-08-19 00:00:00', '2019-08-29 00:00:00', '1', '2019-08-26 15:07:06', '2', null, null, null, '2019-08-26 15:07:06'), ('53', '测试通知', '测试', null, '2019-08-26 00:00:02', '2019-08-28 00:00:00', '37', '2019-08-26 15:13:47', '2', null, null, null, '2019-08-26 15:13:47'), ('54', '测试通知1111111', '这里是通知11111111', null, '2019-09-02 15:45:54', '2019-09-05 00:00:00', '9', '2019-09-02 15:46:16', '2', null, null, null, '2019-09-02 15:46:16'), ('57', '这是个测试通知', null, '<p><img src=\"http://img.baidu.com/hi/jx2/j_0012.gif\"/></p>', '2019-10-15 00:00:00', '2019-10-16 10:31:00', '37', '2019-10-16 10:30:19', '2', null, null, null, '2019-10-16 10:30:19'), ('58', '通知', null, '<p><img src=\"http://img.baidu.com/hi/jx2/j_0010.gif\"/></p>', '2019-10-21 07:00:00', '2019-10-21 09:56:00', '37', '2019-10-21 09:54:58', '2', null, null, null, '2019-10-21 09:54:58'), ('59', '开饭了', null, '<p><img src=\"http://img.baidu.com/hi/jx2/j_0007.gif\"/></p>', '2019-11-08 11:33:40', '2019-11-09 00:00:00', '37', '2019-11-08 11:34:33', '2', null, null, null, '2019-11-08 11:34:33');
COMMIT;

-- ----------------------------
--  Table structure for `gs_order`
-- ----------------------------
DROP TABLE IF EXISTS `gs_order`;
CREATE TABLE `gs_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '申请单号',
  `state` int(1) DEFAULT '0' COMMENT '状态 0 未提交，1 已提交',
  `user_id` int(11) NOT NULL COMMENT '申请人',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `dept_type` tinyint(3) DEFAULT NULL COMMENT '部门类型 1-主要部门 2-兼职部门',
  `user_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请人姓名',
  `contact_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '联系人姓名',
  `contact_tel` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '联系人手机',
  `remark` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '申请说明',
  `enclosure` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '附件 英文逗号分隔',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源申请表';

-- ----------------------------
--  Records of `gs_order`
-- ----------------------------
BEGIN;
INSERT INTO `gs_order` VALUES ('129', '20190919180539010150', '0', '174', null, '1', '2072', '123', '123', '1+2', '', '2019-09-19 18:05:40', null), ('130', '20190919192747010190', '0', '174', null, '1', '2072', 'qweq', '123123', '1313 ', '', '2019-09-19 19:27:47', null), ('131', '20190929091349010151', '0', '180', null, '1', '36/2', '111', '15636548971', '我们部门非常需要这个应用', 'd5bfb6e6-2bac-46d3-88f9-b2e09a9b4142', '2019-09-29 09:13:49', null), ('132', '20190929103909010116', '0', '180', null, '1', '36/2', '11', '111', '1111', '', '2019-09-29 10:39:09', null), ('133', '20190929112234010178', '0', '180', null, '1', '36/2', '111', '111', '111', '', '2019-09-29 11:22:34', null), ('134', '20190929161035010165', '0', '180', null, '1', '36/2', '111', '111', '111', '', '2019-09-29 16:10:35', null), ('135', '20191014172127010165', '0', '166', null, '1', '测试机构管理员账户', '测试', '1008611', '测试', 'c8f93866-dbd2-4569-9754-044544458835', '2019-10-14 17:21:28', null), ('136', '20191014172600010164', '0', '166', null, '1', '测试机构管理员账户', '测试点', '100001', '测试点', '9d73c77b-eb1c-46e3-b96b-099dacce9a70', '2019-10-14 17:26:01', null), ('137', '20191014172723010197', '0', '166', null, '1', '测试机构管理员账户', '我', '我', '我', '', '2019-10-14 17:27:23', null), ('139', '20191015114537010144', '0', '166', null, '1', '测试机构管理员账户', '测试大牛', '111', '2222', '', '2019-10-15 11:45:38', '2019-10-15 14:48:34'), ('140', '20191016091810010142', '0', '166', null, '1', '测试机构管理员账户', '1', '1', '2', '', '2019-10-16 09:18:10', '2019-10-16 14:50:52'), ('141', '20191017161232010103', '0', '166', null, '1', '测试机构管理员账户', '1', '111', '111', '60c7672c-15ef-4353-83f4-f091567fcc73', '2019-10-17 16:12:33', null), ('143', '20191017161440010102', '0', '166', null, '1', '测试机构管理员账户', '一', '1', '一', '7651fd31-efda-4469-9701-74db68dccbb4', '2019-10-17 16:14:40', '2019-10-17 16:20:18'), ('144', '20191017164707010157', '0', '166', null, '1', '测试机构管理员账户', 'qwer', '23123124124', 'qwerqweqwe', '', '2019-10-17 16:47:08', null), ('146', '20191017165757010146', '0', '166', null, '1', '测试机构管理员账户', '0', '0', '0', '', '2019-10-17 16:57:57', null), ('147', '20191018143816010118', '0', '166', null, '1', '测试机构管理员账户', '凹凸曼', '123456', '1', '9a2f2df5-ea77-485b-a4a1-cfa273967d39', '2019-10-18 14:38:17', null), ('148', '20191018144016010122', '0', '166', null, '1', '测试机构管理员账户', '凹凸曼', '1231456', '1', '33d012b5-ac07-4b20-b3df-afac32b847be', '2019-10-18 14:40:17', '2019-10-21 10:40:08'), ('149', '20191018160315010155', '0', '166', null, '1', '测试机构管理员账户', '123123', '123123', '123123', '', '2019-10-18 16:03:15', null), ('150', '20191018161748010168', '0', '166', null, '1', '测试机构管理员账户', '123123123', '123123123', '123123123', '', '2019-10-18 16:17:48', null), ('151', '20191018162416010157', '0', '166', null, '1', '测试机构管理员账户', '222222222', '222222222', '22222222222222', '', '2019-10-18 16:24:17', null), ('153', '20191021104147010145', '0', '166', null, '1', '测试机构管理员账户', '哈哈', '123', '哈哈', '', '2019-10-21 10:41:47', null), ('154', '20191021104816010155', '0', '166', null, '1', '测试机构管理员账户', '哈哈', '1212', '哈哈', '', '2019-10-21 10:48:16', null), ('155', '20191021112208010123', '0', '166', null, '1', '测试机构管理员账户', '哈哈', '121212', '哈哈', '', '2019-10-21 11:22:08', null), ('156', '20191108103429010120', '0', '166', null, '1', '测试机构管理员账户', '1', '1', '1', 'c92d420d-2ea3-4b30-b436-bc5620514c1f', '2019-11-08 10:34:30', null), ('161', '20191108114322010185', '0', '166', null, '1', '测试机构管理员账户', '1', '1', '1', '', '2019-11-08 11:43:23', null), ('162', '20200320172914010131', '0', '224', '1', '1', 'glm', '测试员1', '13568497521', '测试申请', '', '2020-03-20 17:29:14', null), ('163', '20200611141009010136', '0', '231', '18', '1', '丰星雨', '张三', '13356987521', '', '', '2020-06-11 14:10:10', null);
COMMIT;

-- ----------------------------
--  Table structure for `gs_order_app`
-- ----------------------------
DROP TABLE IF EXISTS `gs_order_app`;
CREATE TABLE `gs_order_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `app_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_order_app`
-- ----------------------------
BEGIN;
INSERT INTO `gs_order_app` VALUES ('127', '20190919180539010150-214', '56dba51e-f4db-487e-a3c9-26583954fe98', '192.169.1.1', '2019-09-19 18:05:40'), ('128', '20190919180539010150-215', '56dba51e-f4db-487e-a3c9-26583954fe98', '192.169.1.1', '2019-09-19 18:05:40'), ('129', '20190919192747010190-216', '56dba51e-f4db-487e-a3c9-26583954fe98', '192.169.1.1', '2019-09-19 19:27:47'), ('130', '20190919192747010190-217', '56dba51e-f4db-487e-a3c9-26583954fe98', '192.169.1.1', '2019-09-19 19:27:47'), ('131', '20190929091349010151-235', '5c37e93f-3060-4e9f-b47c-b6da0ddd5b53', '1.1.1.1', '2019-09-29 09:13:49'), ('132', '20190929103909010116-236', '5c37e93f-3060-4e9f-b47c-b6da0ddd5b53', '1.1.1.2', '2019-09-29 10:39:09'), ('133', '20190929112234010178-237', '5c37e93f-3060-4e9f-b47c-b6da0ddd5b53', '1.1.1.1,1.1.1.2', '2019-09-29 11:22:34'), ('134', '20190929161035010165-239', '5c37e93f-3060-4e9f-b47c-b6da0ddd5b53', '1.1.1.1,1.1.1.2', '2019-09-29 16:10:35'), ('135', '20191014172127010165-255', 'cd62141b-aace-4278-ac16-4928eba27653', '12.12.12.3,12.12.12.3', '2019-10-14 17:21:28'), ('136', '20191014172127010165-256', 'cd62141b-aace-4278-ac16-4928eba27653', '12.12.12.3,12.12.12.3', '2019-10-14 17:21:28'), ('137', '20191014172127010165-255', '78edc2d0-3386-486a-8230-52d51728cea6', '1.1.1.1', '2019-10-14 17:21:28'), ('138', '20191014172127010165-256', '78edc2d0-3386-486a-8230-52d51728cea6', '1.1.1.1', '2019-10-14 17:21:28'), ('139', '20191014172600010164-258', 'd713004f-46b5-41fd-a4b1-2113b4fc7f65', '12.12.12.6', '2019-10-14 17:26:01'), ('140', '20191014172723010197-260', 'ff983e6c-9f92-4171-bfdc-6ceffc25b795', '12.12.12.13,12.12.12.14,12.12.12.15,12.12.12.16,12.12.12.16,12.12.12.17', '2019-10-14 17:27:23'), ('144', '20191015114537010144-265', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-15 14:48:34'), ('146', '20191016091810010142-267', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-16 14:50:52'), ('147', '20191017161232010103-271', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-17 16:12:33'), ('149', '20191017161440010102-273', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-17 16:20:18'), ('150', '20191017164707010157-275', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-17 16:47:08'), ('151', '20191017165757010146-277', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-17 16:57:57'), ('152', '20191018143816010118-278', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-18 14:38:17'), ('154', '20191018160315010155-280', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-18 16:03:15'), ('155', '20191018161748010168-281', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-18 16:17:48'), ('156', '20191018162416010157-282', '640de453-c386-4054-b1dc-100617d66fb7', '127.0.0.2,127.0.0.2', '2019-10-18 16:24:17'), ('157', '20191018144016010122-279', '655cbce9-a95e-48b1-9072-4c630b9ad77c', '139.0.0.3,139.0.0.2', '2019-10-21 10:40:08'), ('158', '20191021104147010145-286', '655cbce9-a95e-48b1-9072-4c630b9ad77c', '139.0.0.3,139.0.0.2', '2019-10-21 10:41:47'), ('159', '20191021104816010155-287', '655cbce9-a95e-48b1-9072-4c630b9ad77c', '139.0.0.3,139.0.0.2', '2019-10-21 10:48:16'), ('160', '20191021112208010123-288', '655cbce9-a95e-48b1-9072-4c630b9ad77c', '139.0.0.3,139.0.0.2', '2019-10-21 11:22:08'), ('161', '20191108103429010120-289', '939ce985-ac4b-4469-9a6e-8c0fd9e1c117', '127.0.0.1', '2019-11-08 10:34:30'), ('162', '20191108114322010185-302', '7678ffe6-e572-4895-9d2f-bf9ec300c275', '127.0.0.1,127.0.0.2', '2019-11-08 11:43:23'), ('163', '20200320172914010131-305', '23f19696-ae0c-48c4-a581-b3849533e5fa', '136.153.24.1', '2020-03-20 17:29:15'), ('164', '20200611141009010136-328', 'f47c15d1-7116-45b7-ac49-fd31273e3217', '135.166.12.155', '2020-06-11 14:10:10');
COMMIT;

-- ----------------------------
--  Table structure for `gs_order_item`
-- ----------------------------
DROP TABLE IF EXISTS `gs_order_item`;
CREATE TABLE `gs_order_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_id` int(11) DEFAULT NULL COMMENT '申请单id',
  `order_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请单号',
  `order_item_no` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '订单明细编号',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `res_id` int(11) DEFAULT NULL COMMENT '资源id',
  `ip_id_List` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '绑定ip的id列表',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `dept_type` tinyint(3) DEFAULT NULL COMMENT '部门类型- 1-主要部门 2-兼职部门',
  `contact_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '联系人姓名',
  `contact_tel` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '联系人手机',
  `remark` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '申请说明',
  `type` tinyint(3) DEFAULT NULL COMMENT '订单类型 1-正常订单 2-购物车订单 3-服务咨询订单',
  `version_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '版本号信息',
  `enclosure` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '附件ID，逗号分隔',
  `state` tinyint(3) DEFAULT NULL COMMENT '购物车订单使用 当前状态（0未确认 1未提交、2待审批、3已提交至审批中心、4审批中、5已撤回、6审批通过、7已驳回）\r\n',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_done` tinyint(3) DEFAULT NULL COMMENT '是否完成，用于订单申请通过后给用户发放资源 0-未发放 1-已发放',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=331 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='申请单-资源关联表';

-- ----------------------------
--  Records of `gs_order_item`
-- ----------------------------
BEGIN;
INSERT INTO `gs_order_item` VALUES ('214', '129', '20190919180539010150', '20190919180539010150-214', null, '174', '38', null, '一条流程', '1', '123', '123', '1+2', '1', null, null, '6', '2019-09-19 18:05:26', '1'), ('215', '129', '20190919180539010150', '20190919180539010150-215', null, '174', '39', null, '两条流程', '1', '123', '123', '1+2', '1', null, null, '4', '2019-09-19 18:05:27', '0'), ('216', '130', '20190919192747010190', '20190919192747010190-216', null, '174', '40', null, '三条流程', '1', 'qweq', '123123', '1313 ', '1', null, null, '4', '2019-09-19 19:26:59', '0'), ('217', '130', '20190919192747010190', '20190919192747010190-217', null, '174', '41', null, '四条流程', '1', 'qweq', '123123', '1313 ', '1', null, null, '6', '2019-09-19 19:27:00', '1'), ('218', '130', '20190919192747010190', '20190919192747010190-217', null, '174', '41', null, '四条流程', '1', 'qweq', '123123', '1313 ', '1', '20190919192747010190-217-1', null, '6', '2019-09-19 19:27:00', '0'), ('235', '131', '20190929091349010151', '20190929091349010151-235', null, '180', '38', null, '一条流程', '1', '111', '15636548971', '我们部门非常需要这个应用', '1', null, null, '6', '2019-09-29 09:12:48', '1'), ('236', '132', '20190929103909010116', '20190929103909010116-236', null, '180', '39', null, '两条流程', '1', '11', '111', '1111', '1', null, null, '6', '2019-09-29 10:38:12', '1'), ('237', '133', '20190929112234010178', '20190929112234010178-237', null, '180', '40', null, '三条流程', '1', '111', '111', '111', '1', null, null, '3', '2019-09-29 11:22:23', '0'), ('238', null, null, null, null, '179', '38', null, '一条流程', null, '', '', '', '2', null, null, '1', '2019-09-29 15:59:39', '0'), ('239', '134', '20190929161035010165', '20190929161035010165-239', null, '180', '41', '34,35', '四条流程', '1', '111', '111', '111', '1', null, null, '3', '2019-09-29 16:01:10', '0'), ('240', null, null, null, null, '180', '40', null, '三条流程', null, '', '', '', '2', null, null, '0', '2019-09-29 16:01:11', '0'), ('241', null, null, '', null, '180', '39', null, '两条流程', null, '', '', '', '2', null, null, '0', '2019-09-29 16:01:13', '0'), ('242', null, null, null, null, '180', '38', null, '一条流程', null, '', '', '', '2', null, null, '0', '2019-09-29 16:01:14', '0'), ('288', '155', '20191021112208010123', '20191021112208010123-288', null, '166', '39', '90,91', '两条流程', '1', '哈哈', '121212', '哈哈', '1', null, '', '6', '2019-10-21 11:21:44', '1'), ('289', '156', '20191108103429010120', '20191108103429010120-289', null, '166', '51', '92', '太阳', '1', '1', '1', '1', '1', null, 'c92d420d-2ea3-4b30-b436-bc5620514c1f', '6', '2019-10-25 16:06:04', '1'), ('292', null, null, null, null, '174', '44', null, '测试性应用', null, '', '', '', '2', null, null, '1', '2019-11-05 10:43:31', '0'), ('293', null, null, null, null, '174', '51', null, '太阳', null, '', '', '', '2', null, null, '1', '2019-11-05 10:43:34', '0'), ('294', null, null, null, null, '179', '44', null, '测试性应用', null, '', '', '', '2', null, null, '0', '2019-11-05 11:09:21', '0'), ('295', null, null, null, null, '179', '51', null, '太阳', null, '', '', '', '2', null, null, '0', '2019-11-05 11:09:23', '0'), ('301', null, null, null, null, '166', '51', null, '太阳', null, '', '', '', '2', null, null, '0', '2019-11-08 11:39:35', null), ('302', '161', '20191108114322010185', '20191108114322010185-302', null, '166', '52', '93,94', '月亮', '1', '1', '1', '1', '1', null, '', '7', '2019-11-08 11:43:14', null), ('303', '161', '20191108114322010185', '20191108114322010185-302', null, '166', '52', '93,94', '月亮', '1', '1', '1', '1', '1', '20191108114322010185-302-1', '', '7', '2019-11-08 11:43:14', null), ('304', null, null, null, null, '166', '44', null, '测试性应用', null, '', '', '', '2', null, null, '1', '2019-12-13 11:36:27', '0'), ('305', '162', '20200320172914010131', '20200320172914010131-305', '1', '224', '52', '95', '月亮', '1', '测试员1', '13568497521', '测试申请', '1', null, '', '3', '2020-03-20 16:27:58', '0'), ('306', null, null, null, null, '224', '44', null, '测试性应用', null, '', '', '', '2', null, null, '0', '2020-03-20 16:28:00', '0'), ('307', null, null, null, null, '224', '51', null, '太阳', null, '', '', '', '2', null, null, '0', '2020-03-20 16:28:02', '0'), ('308', null, null, null, null, '1', '44', null, '测试性应用', null, '', '', '', '2', null, null, '1', '2020-03-24 14:14:06', '0'), ('309', null, null, null, null, '1', '40', null, '三条流程', null, '', '', '', '2', null, null, '0', '2020-03-24 14:37:46', '0'), ('312', null, null, null, null, '219', '52', null, '月亮', null, '', '', '', '2', null, null, '1', '2020-04-02 15:48:41', '0'), ('313', null, null, null, null, '219', '44', null, '测试性应用', null, '', '', '', '2', null, null, '0', '2020-04-02 15:57:54', '0'), ('314', null, null, null, null, '219', '41', null, '四条流程', null, '', '', '', '2', null, null, '0', '2020-04-02 15:57:56', '0'), ('315', null, null, null, null, '219', '38', null, 'DCSB', null, '', '', '', '2', null, null, '0', '2020-04-02 15:57:58', '0'), ('316', null, null, null, null, '1', '52', null, '月亮', null, '', '', '', '2', null, null, '0', '2020-04-02 16:32:13', '0'), ('317', null, null, null, null, '1', '51', null, '太阳', null, '', '', '', '2', null, null, '0', '2020-04-02 16:32:41', '0'), ('325', null, null, null, null, '1', '51', null, '太阳', null, '', '', '', '2', null, null, '0', '2020-04-20 13:40:01', null), ('326', null, null, null, null, '1', '41', null, '四条流程', null, '', '', '', '2', null, null, '0', '2020-04-24 16:23:48', '0'), ('327', null, null, null, null, '1', '52', null, '月亮', null, '', '', '', '2', null, null, '2', '2020-06-10 17:27:47', null), ('328', '163', '20200611141009010136', '20200611141009010136-328', '18', '231', '44', '96', '测试性应用', '1', '张三', '13356987521', '', '1', null, '', '5', '2020-06-11 13:56:09', '0'), ('329', null, null, null, null, '231', '52', null, '月亮', null, '', '', '', '2', null, null, '0', '2020-06-11 13:56:10', '0'), ('330', null, null, null, null, '231', '51', null, '太阳', null, '', '', '', '2', null, null, '0', '2020-06-11 13:56:11', '0');
COMMIT;

-- ----------------------------
--  Table structure for `gs_res`
-- ----------------------------
DROP TABLE IF EXISTS `gs_res`;
CREATE TABLE `gs_res` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
  `dept_id` int(11) DEFAULT NULL COMMENT '资源源部门id',
  `dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源源部门名称',
  `category` int(11) DEFAULT NULL COMMENT '分类',
  `type` tinyint(2) DEFAULT NULL COMMENT '类型 0-普通资源 1-服务类资源',
  `ap_config_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '流程配置编码',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT '暂无简介' COMMENT '描述',
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标',
  `popular` tinyint(2) DEFAULT '0' COMMENT '热门资源。0 否 1 是',
  `state` tinyint(2) DEFAULT '0' COMMENT '状态 0-待上线 1-上线 2-下架',
  `banner` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'banner图url',
  `introduction` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '产品详情',
  `res_source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '应用来源',
  `manufacturer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '厂商',
  `manufacturer_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '厂商链接',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `modify_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源表';

-- ----------------------------
--  Records of `gs_res`
-- ----------------------------
BEGIN;
INSERT INTO `gs_res` VALUES ('38', 'DCSB', null, null, '2', '1', null, '1', '0cc68277-162a-412b-8be6-e78a8351c5a2', '0', '1', 'c47f1960-5773-4f79-b467-82f93fa1488b', '{\"moduleList\":[{\"title\":\"七二万人\",\"content\":\"\",\"imgUrl\":\"4af541a9-3c7d-45d7-b47f-e23f48a9a95e\",\"fileInfo\":null}]}', '1', null, 'http://192.168.1.246:8083/provide', '2019-10-02 17:06:01', '2020-03-23 16:29:36'), ('39', '两条流程', null, null, '2', '1', null, '23333', '78574271-5173-470f-a301-9c7029a6e958', '0', '1', 'b09307b9-293e-4dec-b386-54b7daa1840f', '{\"moduleList\":[]}', '2', null, null, '2019-10-03 16:07:02', '2019-10-21 10:49:47'), ('40', '三条流程', null, null, '2', '1', null, '3', '684ebc46-418d-44e6-b80b-a261b5da56f4', '0', '1', 'http://192.168.1.95:50013/file/origin/common/1568884100399_17671.jpg', '{\"moduleList\":[{\"title\":\"111\",\"content\":\"23123123\",\"imgUrl\":\"http://192.168.1.95:50013/file/origin/common/1570694706284_96313.jpg\"}]}', '3', null, null, '2019-10-04 17:08:26', '2020-04-02 17:42:02'), ('41', '四条流程', null, null, '2', '1', null, '4', '47d655f1-0ef2-4e18-afae-456c634c8081', '0', '1', 'http://192.168.1.95:50013/file/origin/common/1568884168613_53956.docx', '{\"moduleList\":[]}', '4', null, null, '2019-10-05 17:09:32', '2019-10-16 15:38:41'), ('42', '测试应用1', null, null, '27', '1', null, '111', '684ebc46-418d-44e6-b80b-a261b5da56f4', '0', '2', 'http://192.168.1.95:50013/file/origin/common/1568950486312_99992.png', '{\"moduleList\":[{\"title\":\"123\",\"content\":\"\",\"imgUrl\":\"http://192.168.1.95:50013/file/origin/common/1568950528966_68156.png\"}]}', '111', null, null, '2020-03-10 11:36:04', '2020-04-17 15:49:05'), ('44', '测试性应用', null, null, '31', '1', null, '这是测试性数据', '684ebc46-418d-44e6-b80b-a261b5da56f4', '0', '1', 'dc10ac90-96cd-418f-a9fb-aaa9ae292450', '{\"moduleList\":[]}', '123123123', null, null, '2020-04-16 01:31:11', '2020-06-11 14:22:47'), ('51', '太阳', null, null, '56', '1', null, '这是太阳', '684ebc46-418d-44e6-b80b-a261b5da56f4', '0', '1', '7b59b8e2-19b3-433a-8c34-75bf7eac2f97', '{\"moduleList\":[{\"title\":\"介绍\",\"content\":\"这是介绍\",\"imgUrl\":\"10ae5d03-b201-47ef-9aac-a8e080dc9bdf\",\"fileInfo\":null}]}', '太阳系', null, null, '2020-04-16 11:42:24', '2020-04-17 16:09:51'), ('52', '月亮', null, null, '56', '1', null, '好的应用', 'fb639f4c-e4eb-40ee-b286-0c471e53750e', '0', '1', 'f154b07f-2e9d-43fe-9d7f-51a688228a1e', '{\"moduleList\":[]}', '试试', null, null, '2020-04-17 11:42:24', '2020-04-17 16:10:00');
COMMIT;

-- ----------------------------
--  Table structure for `gs_res_doc`
-- ----------------------------
DROP TABLE IF EXISTS `gs_res_doc`;
CREATE TABLE `gs_res_doc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `res_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_size` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_res_id` (`res_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_res_doc`
-- ----------------------------
BEGIN;
INSERT INTO `gs_res_doc` VALUES ('6', '42', '图片1.png', null, 'http://192.168.1.95:50013/file/origin/common/1568950540036_93710.png', '2019-09-20 11:36:04'), ('7', '45', 'u=2350171032,3227234175&fm=26&gp=0.jpg', null, 'http://192.168.1.95:50013/file/origin/common/1571190715346_19955.jpg', '2019-10-16 09:51:59'), ('9', '46', '测试.txt', null, 'http://192.168.1.95:50013/file/origin/common/1571192126603_15840.txt', '2019-10-16 10:23:51'), ('13', '49', null, null, '749ae88b-3a80-446e-8638-f2c514a3f119', '2019-10-17 16:33:38'), ('14', '50', null, null, 'a100cb79-e126-4cea-ad67-23039ee1829f', '2019-10-17 16:39:21'), ('17', '51', null, null, 'f854ecc0-f80f-4000-b6a6-bf0cc24c25e8', '2019-10-18 18:58:33'), ('18', '38', null, null, 'f3e2c5d0-9fa8-4d4b-a25c-6978bb8a0725', '2019-11-07 10:12:13');
COMMIT;

-- ----------------------------
--  Table structure for `gs_res_featrue`
-- ----------------------------
DROP TABLE IF EXISTS `gs_res_featrue`;
CREATE TABLE `gs_res_featrue` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键（自增）',
  `feature_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '产品特色名称',
  `feature_img_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '产品特色图片',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',
  `display_status` int(1) DEFAULT NULL COMMENT '显示状态 0显示 1隐藏',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_res_featrue`
-- ----------------------------
BEGIN;
INSERT INTO `gs_res_featrue` VALUES ('1', '丰富的产品体系', '459f847d-2fcb-4031-bc70-c46a7e085810', '提供云基础产品、数据产品、应用产品等，助理政务机构业务创新', '0', '3', '2019-08-02 14:33:02'), ('2', '强大的连接能力', 'da548d52-4e1d-47b3-8415-55a898cd23c5', '通过大数据与平台资源整合的能力\r\n\r\n为政务机构提供更贴近实际业务的服务', '0', '2', '2019-08-02 14:33:15'), ('3', '海量的运营经验', 'dc219bda-f799-4837-94de-99ccd75a1971', '多年大数据归集经验，多种安全你保护机制，保证运营的稳定和安全', '0', '1', '2019-08-02 15:22:44'), ('7', '混合云管理', '75fcdf5d-d0fe-4ef1-88b1-a5dd9d53b05e', '提供全方位混合云管理方案，满足多层次、全方位的需求', '0', '4', '2019-08-05 10:24:02'), ('9', '测试又222', '63553b86-cdb2-454e-8cb9-d80a6686cc6c', '测试222', '1', '5', '2019-10-16 14:57:11'), ('14', '小猫', '905b9cd6-bc4e-474e-adcf-9f1563450be2', '小猫', '0', '6', '2019-10-17 16:43:14');
COMMIT;

-- ----------------------------
--  Table structure for `gs_res_intention`
-- ----------------------------
DROP TABLE IF EXISTS `gs_res_intention`;
CREATE TABLE `gs_res_intention` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `user_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户姓名',
  `dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户部门',
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系方式',
  `res_id` int(11) DEFAULT NULL COMMENT '资源id',
  `res_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源名称',
  `content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '意向内容',
  `state` tinyint(3) DEFAULT NULL COMMENT '状态 1-未沟通 2-已沟通',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
  `files` varchar(1023) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件 英文逗号分隔',
  `op_user_id` int(11) DEFAULT NULL COMMENT '操作人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资源意向表';

-- ----------------------------
--  Records of `gs_res_intention`
-- ----------------------------
BEGIN;
INSERT INTO `gs_res_intention` VALUES ('1', '1', '123123', '123123', '123123', '1', '123123', '111', '2', '123123', '[{\"fileName\":\"u3561.png\",\"path\":\"http://192.168.1.95:50013/file/origin/supermarket/1566472333703_25734.png\"}]', '1', '2019-08-21 15:39:35'), ('2', '168', '机构管理员测试人员1', '省委党校', '1', '21', '服务233', '呃呃呃', '2', null, null, '1', '2019-09-04 09:18:35'), ('3', '168', '机构管理员测试人员1', '省委党校', '18868106079', '21', '服务233', '222', '2', null, null, '1', '2019-09-04 09:19:48'), ('4', '168', '机构管理员测试人员1', '省委党校', '18868106079', '21', '服务233', '555', '2', null, null, '1', '2019-09-04 09:26:59'), ('5', '166', '测试机构管理员账户', '省政府办公厅', '15757181159', '43', '服务应用-单流程', '这是啥呀', '2', null, null, '1', '2019-10-15 15:19:20');
COMMIT;

-- ----------------------------
--  Table structure for `gs_res_intention_remark`
-- ----------------------------
DROP TABLE IF EXISTS `gs_res_intention_remark`;
CREATE TABLE `gs_res_intention_remark` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '内容',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `intention_id` int(11) DEFAULT NULL COMMENT '意向id',
  `file` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件',
  `op_user_id` int(11) DEFAULT NULL COMMENT '备注人id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_res_intention_remark`
-- ----------------------------
BEGIN;
INSERT INTO `gs_res_intention_remark` VALUES ('1', '213112', '2019-08-30 14:31:39', '1', null, '1'), ('6', '333', '2019-09-04 09:57:42', '4', '[{\"id\":\"2b291450-a43c-4366-ba2c-69d30d6b74e1\",\"fileName\":\"1562917199894_78603.png\",\"path\":\"http://192.168.1.95:50013/file/origin/common/1567562257555_92591.png\"},{\"id\":\"90323cd5-04ff-4358-8f4f-d6ae3082f83a\",\"fileName\":\"clock.html\",\"path\":\"http://192.168.1.95:50013/file/origin/common/1567562260806_09251.html\"}]', '1'), ('7', '444', '2019-09-04 09:58:12', '4', '[{\"id\":\"cdf2869c-fbc1-450b-8ee6-79f3640159dc\",\"fileName\":\"1562917199894_78603.png\",\"path\":\"http://192.168.1.95:50013/file/origin/common/1567562291026_04848.png\"}]', '1'), ('8', 'ttt', '2019-09-04 09:58:17', '4', '[]', '1'), ('9', '测试', '2019-10-15 15:25:24', '5', '[{\"id\":\"a73ac41b-6242-40dc-96d5-7c08089b90dc\",\"fileName\":\"1571045158541_83078.txt\",\"path\":\"http://192.168.1.95:50013/file/origin/common/1571124322483_62760.txt\"}]', '1'), ('10', '不知道', '2019-10-21 17:10:17', '5', '[]', '166');
COMMIT;

-- ----------------------------
--  Table structure for `gs_self_system`
-- ----------------------------
DROP TABLE IF EXISTS `gs_self_system`;
CREATE TABLE `gs_self_system` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '唯一代码',
  `content` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '系统简介',
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ip地址 英文逗号分隔',
  `user_id` int(11) NOT NULL COMMENT '所属用户id',
  `def` tinyint(1) DEFAULT '0' COMMENT '是否默认。0 否， 1 是',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `state` tinyint(1) DEFAULT '0' COMMENT '状态 0 正常，1 作废',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='自建系统';

-- ----------------------------
--  Records of `gs_self_system`
-- ----------------------------
BEGIN;
INSERT INTO `gs_self_system` VALUES ('1', '测试系统1', 'test1', '测试', '172.0.0.1', '1', '1', '2019-07-17 12:38:48', '2019-07-17 16:41:35', '0'), ('2', '测试系统2', 'test2', '测试', '172.0.0.1', '1', '0', '2019-07-17 12:39:18', '2019-07-17 16:10:13', '0'), ('3', '测试系统3', 'test3', '测试', '172.0.0.1', '1', '0', '2019-07-17 12:39:51', null, '1'), ('4', '2', '2', '2', '2', '2', '1', '2019-07-17 12:47:47', '2019-07-17 16:45:59', '0'), ('5', '测试系统5', 'test5', '测试', '172.0.0.1', '2', '1', '2019-07-17 12:48:10', null, '1'), ('8', '测试系统8', 'test8', '测试', '172.0.0.1', '2', '0', '2019-07-17 13:02:15', '2019-07-17 16:45:59', '0');
COMMIT;

-- ----------------------------
--  Table structure for `gs_user_apply`
-- ----------------------------
DROP TABLE IF EXISTS `gs_user_apply`;
CREATE TABLE `gs_user_apply` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '订单编号',
  `flow_config_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '流程配置编码',
  `state` int(11) DEFAULT NULL COMMENT '状态 1-新建 2-完成 3-驳回 4-删除',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `apply_form_id` int(11) DEFAULT NULL COMMENT '申请单ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用户申请流程';

-- ----------------------------
--  Table structure for `gs_user_notice`
-- ----------------------------
DROP TABLE IF EXISTS `gs_user_notice`;
CREATE TABLE `gs_user_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `notice_id_list` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '未读通知id列表-每个id使用 “，”分隔',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=232 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_user_notice`
-- ----------------------------
BEGIN;
INSERT INTO `gs_user_notice` VALUES ('1', '1', '56,57,'), ('2', '2', '1,43,45,53,54,55,56,57,58,59,'), ('3', '3', '3,43,45,53,54,55,56,57,58,59,'), ('5', '166', '59,'), ('6', '166', '59,'), ('7', '166', '59,'), ('8', '166', '59,'), ('9', '166', '59,'), ('10', '166', '59,'), ('11', '168', '55,56,57,58,59,'), ('12', '168', '55,56,57,58,59,'), ('13', '168', '55,56,57,58,59,'), ('14', '168', '55,56,57,58,59,'), ('15', '168', '55,56,57,58,59,'), ('16', '168', '55,56,57,58,59,'), ('17', '168', '55,56,57,58,59,'), ('18', '168', '55,56,57,58,59,'), ('19', '168', '55,56,57,58,59,'), ('20', '168', '55,56,57,58,59,'), ('21', '168', '55,56,57,58,59,'), ('22', '168', '55,56,57,58,59,'), ('23', '168', '55,56,57,58,59,'), ('24', '168', '55,56,57,58,59,'), ('25', '168', '55,56,57,58,59,'), ('26', '168', '55,56,57,58,59,'), ('27', '168', '55,56,57,58,59,'), ('28', '166', '59,'), ('29', '166', '59,'), ('30', '166', '59,'), ('31', '166', '59,'), ('32', '166', '59,'), ('33', '166', '59,'), ('34', '166', '59,'), ('35', '166', '59,'), ('36', '166', '59,'), ('37', '166', '59,'), ('38', '166', '59,'), ('39', '166', '59,'), ('40', '166', '59,'), ('41', '166', '59,'), ('42', '166', '59,'), ('43', '166', '59,'), ('44', '166', '59,'), ('45', '166', '59,'), ('46', '166', '59,'), ('47', '166', '59,'), ('48', '168', '55,56,57,58,59,'), ('49', '166', '59,'), ('50', '166', '59,'), ('51', '168', '55,56,57,58,59,'), ('52', '166', '59,'), ('53', '166', '59,'), ('54', '166', '59,'), ('55', '166', '59,'), ('56', '166', '59,'), ('57', '166', '59,'), ('58', '168', '55,56,57,58,59,'), ('59', '166', '59,'), ('60', '166', '59,'), ('61', '166', '59,'), ('62', '166', '59,'), ('63', '166', '59,'), ('64', '168', '55,56,57,58,59,'), ('65', '166', '59,'), ('66', '168', '55,56,57,58,59,'), ('67', '166', '59,'), ('68', '168', '55,56,57,58,59,'), ('69', '166', '59,'), ('70', '168', '55,56,57,58,59,'), ('71', '168', '55,56,57,58,59,'), ('72', '168', '55,56,57,58,59,'), ('73', '168', '55,56,57,58,59,'), ('74', '168', '55,56,57,58,59,'), ('75', '168', '55,56,57,58,59,'), ('76', '168', '55,56,57,58,59,'), ('77', '166', '59,'), ('78', '168', '55,56,57,58,59,'), ('79', '166', '59,'), ('80', '166', '59,'), ('81', '166', '59,'), ('82', '166', '59,'), ('83', '168', '55,56,57,58,59,'), ('84', '168', '55,56,57,58,59,'), ('85', '168', '55,56,57,58,59,'), ('86', '168', '55,56,57,58,59,'), ('87', '168', '55,56,57,58,59,'), ('88', '168', '55,56,57,58,59,'), ('89', '168', '55,56,57,58,59,'), ('90', '168', '55,56,57,58,59,'), ('91', '168', '55,56,57,58,59,'), ('92', '168', '55,56,57,58,59,'), ('93', '166', '59,'), ('94', '166', '59,'), ('95', '166', '59,'), ('96', '168', '55,56,57,58,59,'), ('97', '168', '55,56,57,58,59,'), ('98', '168', '55,56,57,58,59,'), ('99', '168', '55,56,57,58,59,'), ('100', '168', '55,56,57,58,59,'), ('101', '166', '59,'), ('102', '166', '59,'), ('103', '166', '59,'), ('104', '166', '59,'), ('105', '166', '59,'), ('106', '166', '59,'), ('107', '168', '55,56,57,58,59,'), ('108', '166', '59,'), ('109', '166', '59,'), ('110', '166', '59,'), ('111', '168', '55,56,57,58,59,'), ('112', '168', '55,56,57,58,59,'), ('113', '168', '55,56,57,58,59,'), ('114', '168', '55,56,57,58,59,'), ('115', '168', '55,56,57,58,59,'), ('116', '168', '55,56,57,58,59,'), ('117', '168', '55,56,57,58,59,'), ('118', '168', '55,56,57,58,59,'), ('119', '169', '55,56,57,58,59,'), ('120', '169', '55,56,57,58,59,'), ('121', '169', '55,56,57,58,59,'), ('122', '169', '55,56,57,58,59,'), ('123', '168', '55,56,57,58,59,'), ('124', '169', '55,56,57,58,59,'), ('125', '169', '55,56,57,58,59,'), ('126', '169', '55,56,57,58,59,'), ('127', '169', '55,56,57,58,59,'), ('128', '169', '55,56,57,58,59,'), ('129', '169', '55,56,57,58,59,'), ('130', '169', '55,56,57,58,59,'), ('131', '169', '55,56,57,58,59,'), ('132', '168', '55,56,57,58,59,'), ('133', '166', '59,'), ('134', '168', '55,56,57,58,59,'), ('135', '168', '55,56,57,58,59,'), ('136', '166', '59,'), ('137', '169', '55,56,57,58,59,'), ('138', '169', '55,56,57,58,59,'), ('139', '169', '55,56,57,58,59,'), ('140', '166', '59,'), ('141', '166', '59,'), ('142', '169', '55,56,57,58,59,'), ('143', '168', '55,56,57,58,59,'), ('144', '168', '55,56,57,58,59,'), ('145', '168', '55,56,57,58,59,'), ('146', '166', '59,'), ('147', '168', '55,56,57,58,59,'), ('148', '166', '59,'), ('149', '166', '59,'), ('150', '166', '59,'), ('151', '169', '55,56,57,58,59,'), ('152', '169', '55,56,57,58,59,'), ('153', '169', '55,56,57,58,59,'), ('154', '166', '59,'), ('155', '166', '59,'), ('156', '166', '59,'), ('157', '166', '59,'), ('158', '168', '55,56,57,58,59,'), ('159', '166', '59,'), ('160', '166', '59,'), ('161', '169', '55,56,57,58,59,'), ('162', '169', '55,56,57,58,59,'), ('163', '168', '55,56,57,58,59,'), ('164', '166', '59,'), ('165', '166', '59,'), ('166', '166', ''), ('167', '169', '55,56,57,58,59,'), ('168', '174', '55,56,57,58,59,'), ('169', '174', '55,56,57,58,59,'), ('170', '174', '55,56,57,58,59,'), ('171', '174', '55,56,57,58,59,'), ('172', '175', '55,56,57,58,59,'), ('173', '175', '55,56,57,58,59,'), ('174', '175', '55,56,57,58,59,'), ('175', '175', '55,56,57,58,59,'), ('176', '179', '55,56,57,58,59,'), ('177', '179', '55,56,57,58,59,'), ('178', '180', '56,57,58,59,'), ('179', '179', '55,56,57,58,59,'), ('180', '180', '56,57,58,59,'), ('181', '187', '56,57,58,59,'), ('182', '187', '56,57,58,59,'), ('183', '187', '56,57,58,59,'), ('184', '187', '56,57,58,59,'), ('185', '187', '56,57,58,59,'), ('186', '187', '56,57,58,59,'), ('187', '187', '56,57,58,59,'), ('188', '209', ''), ('189', '209', ''), ('190', '209', ''), ('191', '209', ''), ('192', '209', ''), ('193', '209', ''), ('194', '209', ''), ('195', '209', ''), ('196', '209', ''), ('197', '209', ''), ('198', '209', ''), ('199', '209', ''), ('200', '209', ''), ('201', '209', ''), ('202', '204', ''), ('203', '220', ''), ('204', '220', ''), ('205', '219', ''), ('206', '219', ''), ('207', '219', ''), ('208', '219', ''), ('209', '219', ''), ('210', '219', ''), ('211', '219', ''), ('212', '219', ''), ('213', '219', ''), ('214', '219', ''), ('215', '219', ''), ('216', '219', ''), ('217', '219', ''), ('218', '219', ''), ('219', '219', ''), ('220', '228', ''), ('221', '228', ''), ('222', '224', ''), ('223', '224', ''), ('224', '224', ''), ('225', '228', ''), ('226', '228', ''), ('227', '228', ''), ('228', '228', ''), ('229', '230', ''), ('230', '230', ''), ('231', '231', '');
COMMIT;

-- ----------------------------
--  Table structure for `gs_user_res`
-- ----------------------------
DROP TABLE IF EXISTS `gs_user_res`;
CREATE TABLE `gs_user_res` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `res_id` int(11) DEFAULT NULL COMMENT '资源id',
  `common_use` tinyint(3) DEFAULT NULL COMMENT '常用 0-否 1-是',
  `state` tinyint(3) DEFAULT NULL COMMENT '状态 1-未生效 2-已生效 3-已过期',
  `src_dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '来源',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49713 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `gs_user_res`
-- ----------------------------
BEGIN;
INSERT INTO `gs_user_res` VALUES ('18', '37', '174', '41', '1', '2', '申请资源发放平台', '2019-09-20 18:13:30', '2019-12-11 17:24:54'), ('20', '37', '174', '38', '0', '2', '申请资源发放平台', '2019-09-29 09:27:30', '2019-12-11 17:24:54'), ('21', '37', '180', '38', '0', '2', '申请资源发放平台', '2019-09-29 09:27:30', '2019-12-11 17:24:54'), ('22', '37', '180', '39', '0', '2', '申请资源发放平台', '2019-09-29 10:41:00', '2019-12-11 17:24:55'), ('26', '37', '166', '38', '0', '2', '申请资源发放平台', '2019-10-18 16:25:00', '2020-01-08 14:55:58'), ('90', '37', '166', '39', '0', '2', '申请资源发放平台', '2019-10-21 11:24:00', '2020-01-08 14:56:00'), ('92', '37', '166', '51', '0', '2', '申请资源发放平台', '2019-11-08 11:30:30', '2020-01-08 14:56:07'), ('93', '37', '181', '51', '1', '2', '机构管理员-应用权限管理-机构管理员授权资源', '2019-11-27 14:19:32', '2019-12-11 17:24:55'), ('94', null, '1', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('95', null, '54', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('96', null, '166', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('97', null, '175', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('98', null, '179', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('99', null, '180', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('100', null, '181', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('101', null, '182', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('102', null, '188', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('103', null, '196', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('104', null, '197', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('105', null, '198', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('106', null, '199', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('107', null, '204', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('108', null, '205', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('109', null, '208', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('110', null, '209', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('111', null, '211', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('112', null, '212', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('113', null, '213', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('114', null, '217', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('115', null, '218', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('116', null, '219', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('117', null, '220', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('118', null, '221', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('119', null, '223', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('120', null, '224', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('121', null, '226', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('122', null, '228', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('123', null, '229', '42', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:26:43', '2020-04-02 11:26:43'), ('28925', null, '1', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28926', null, '54', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28927', null, '166', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28928', null, '175', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28929', null, '179', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28930', null, '180', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28931', null, '181', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28932', null, '182', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28933', null, '188', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28934', null, '196', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28935', null, '197', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28936', null, '198', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28937', null, '199', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28938', null, '204', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28939', null, '205', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28940', null, '208', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28941', null, '209', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28942', null, '211', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28943', null, '212', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28944', null, '213', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28945', null, '217', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28946', null, '218', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28947', null, '219', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28948', null, '220', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28949', null, '221', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28950', null, '223', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28951', null, '224', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28952', null, '226', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28953', null, '228', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('28954', null, '229', '44', '1', '2', '机构管理员-应用权限管理-机构管理员一键授权资源', '2020-04-02 11:28:24', '2020-04-02 11:28:24'), ('49712', null, '1', '52', '1', '2', '机构管理员-应用权限管理-机构管理员授权资源', '2020-06-17 10:37:50', '2020-06-17 10:37:50');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
